Fatal error: Uncaught exception 'Exception' with message 'Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':/store.iconbc.com/product/catalog/view/theme/b2b/stylesheet/globals.css) LEFT ' in /var/www/b2b/system/library/db/mysqli.php on line 40 Exception: Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':/store.iconbc.com/product/catalog/view/theme/b2b/stylesheet/globals.css) LEFT ' at line 2
Error No: 1064
SELECT COUNT(DISTINCT p.stockid) AS total FROM product_to_category pc INNER JOIN stockmaster p on p.stockid = pc.stockid and pc.category_id in (920https:/store.iconbc.com/product/catalog/view/theme/b2b/stylesheet/globals.css) LEFT JOIN product_description d on p.stockid = d.stockid WHERE 1 and discontinued ='0' and enabled='1' and d.loggedin = 0 in /var/www/b2b/system/library/db/mysqli.php on line 40 Call Stack: 0.0001 236048 1. {main}() /var/www/b2b/index.php:0 0.0019 352776 2. start() /var/www/b2b/index.php:32 0.0019 354480 3. require_once('/var/www/b2b/system/framework.php') /var/www/b2b/system/startup.php:130 0.0057 541200 4. Front->dispatch() /var/www/b2b/system/framework.php:119 0.0111 963288 5. Front->execute() /var/www/b2b/system/engine/front.php:28 0.0111 963288 6. Action->execute() /var/www/b2b/system/engine/front.php:33 0.0111 967496 7. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0111 967880 8. ControllerStartupRouter->index() /var/www/b2b/system/engine/action.php:51 0.0112 968768 9. Action->execute() /var/www/b2b/catalog/controller/startup/router.php:25 0.0112 974904 10. call_user_func_array:{/var/www/b2b/system/engine/action.php:51}() /var/www/b2b/system/engine/action.php:51 0.0112 979440 11. ControllerProductCategory->index() /var/www/b2b/system/engine/action.php:51 0.0214 1476976 12. Proxy->getTotalProducts() /var/www/b2b/catalog/controller/product/category.php:328 0.0214 1477328 13. Proxy->__call() /var/www/b2b/catalog/controller/product/category.php:328 0.0214 1478464 14. call_user_func_array:{/var/www/b2b/system/engine/proxy.php:25}() /var/www/b2b/system/engine/proxy.php:25 0.0214 1479640 15. Loader->{closure:/var/www/b2b/system/engine/loader.php:153-197}() /var/www/b2b/system/engine/proxy.php:25 0.0215 1481240 16. call_user_func_array:{/var/www/b2b/system/engine/loader.php:184}() /var/www/b2b/system/engine/loader.php:184 0.0215 1481896 17. ModelCatalogProduct->getTotalProducts() /var/www/b2b/system/engine/loader.php:184 0.0215 1483160 18. DB->query() /var/www/b2b/catalog/model/catalog/product.php:488 0.0215 1483296 19. DB\MySQLi->query() /var/www/b2b/system/library/db.php:16